Home page
Release Information
Reality on the Web
MultiValue Compatibility
Documentation Overview
Installation Guides
User's Reference
English Reference
Proc Reference
DataBasic Reference
Editor Reference
Screen Editor Reference
Resilience
SQL for Reality
About this Section
Introduction
Software Compliance
Assumed Knowledge
Contents

Related Documents
Conventions

Introduction to SQL for Reality
Introduction
What are ODBC and JDBC?
SQL for Reality
SQL/JDBC
Standards

SQL/ODBC for Reality
RealSQL Driver
Distributed Transactions

SQL/JDBC for Reality
Reality Database as an SQL Data Source
Accessing Reality Files using SQL
What is a Reality SQL Catalog?
Client/Server Interface
Definition of the SQL Environment in Reality
Administration Using SQLM
Setting up an SQL Catalog
Multiple Account Catalogs
SQL-Reality Relationships

SQL Catalog Files
SQLTABLES File
SQLCOLUMNS File
SQLINDEXES File

Creating a Reality SQL Catalog
Naming of Tables, Columns and Indexes
Reviewing Reality Dictionaries
Using Existing Reality Data Dictionaries
Checking a Column Definition
Indexes

Listing Columns and Indexes in Reality
Listing the Columns in a Table
Listing the Indexes for a Table

Setting Up a Working System
Setting-up the Host System
Setting-up the SQL/ODBC Software on a PC
Configuring the Standard Network Interface
Setting-up the SQL/ODBC Data Source

Setting-up the SQL/JDBC Software on a Client System
Connecting using SQL/JDBC

Troubleshooting
Host Configuration
Reality User-id
SQL/ODBC
SQL/JDBC

Catalog Administration from TCL
Introduction
Syntax
Using a Select List
Creating the SQL Environment
SQL Catalog Files
Main Menu

Using the SQLM Menu Options
Entering File and Table Names
Selecting from a List
Amendments Screens

Option 1: Create New Table Definitions
Initial Procedure
Automatic Conversion of Data/Index Definitions
Manual Selection of Data/Index Definitions
Creating a Table for a File with no Data Definition Items

Option 2: Create Alternative View
Option 3: View Table Definitions
Viewing Privilege Grants
Viewing Primary Keys
Viewing Foreign Keys
Viewing Column Definitions
Viewing Index Definitions

Option 4: Amend Table Definitions
Updating Privilege Grants
Updating Primary Keys
Updating Foreign Keys
Updating a Column Definition
Updating Index Definitions
Toggling Update Permission

Option 5: Regenerate Table
Option 6: Rename Table
Option 7: Remove Table From SQL Environment
Option 8: Verify Table(s)

Catalog Administration from a PC
What is WinSQLM?
Starting WinSQLM
Context Sensitive Help

Administering and Connecting to an SQL Catalog
Configuring a Data Source
Connecting to an SQL/ODBC Data Source

Working with the WinSQLM Window
Menu Commands
Toolbar Commands

Creating a New Table Definition - Overview
Creating a New Table using Manual Selection of Data/Index Definitions
Creating a New Table using Automatic Conversion of All Data/Index Definitions
Creating a New Table using Automatic Conversion of Selected Data/Index Definitions
Creating a New Table For a File with No Data Definition Items
Opening a Table Definition
Viewing and Updating a Table Definition
Columns Page
Alternative View of Column Definition
Adding a Column Definition
Updating Column Definitions
Changing a Cell
Renaming a Table
Deleting a Table Definition

Indexes Page
Deleting an Index
Adding an Index

Privileges Page
Updating Current Privilege Grants
Adding a New User or Security Profile Grant
Deleting a User or Security Profile Grant

Table Information Page
File Information Page
ODBC Test Page

SQL Column and Index Definitions
SQL Column Definition Fields
Conversion Codes in an SQL Column Definition
SQL Conversions to/from a Directly Connected Terminal
Data Generation
Output Conversion
Input Conversion
Update Conversion

SQL Index Definition Fields

Table/Column Definition Design
Introduction
Handling Multivalues and Subvalues
Accessing Multivalues or Subvalues in Columns
Examples of Handling Different Types of Multivalued Attributes
Techniques for Handling Multivalues
Examples of Handling Multivalued Data in a Single Row
Examples of Handling Related Multivalued Fields

Choosing Data Types
Column Type
Precision
Scale

Choosing Primary Keys

Application Index Design
Difference between SQL and Reality Indexes
Two-Step Index Creation Using TCL
One-Step Index Creation Using SQL
Differences Between TCL and SQL Creation Mechanisms
Processing a Query
Optimising a Query using Indexes

SQL Query Optimisation
Optimisation Methods
SQL Query Optimisation Rules
The use of Multiple AND/OR Clauses
Join Optimisation
LIKE Optimisation
Debugging Features
Index Matching Algorithm
Mismatch Problems
The ?missing values? Problem

Recommendations for Creating Indexes
Restrictions on Creating Indexes

SQL Statements Supported by Reality
Reality SQL
Data Types
Functions
SQL Views
Null Handling
Binary Data Types

Standards Compliance
SQL/ODBC
SQL/JDBC
Data Types

The SQL Command and Statements
The SQL command
SQL Statements

ALTER TABLE Statement
CALL Statement
CREATE INDEX Statement
CREATE PROCEDURE Statement
CREATE TABLE Statement
DELETE Statement
DROP INDEX Statement
DROP PROCEDURE Statement
DROP TABLE Statement
GRANT Statement
INSERT Statement
REVOKE Statement
SELECT Statement
UPDATE Statement
VERIFY Statement
SQL Search Condition
SQL Expression

SQL Stored Procedures
Writing Stored Procedures
BEGIN/END Statements
BREAK Statement
CONTINUE Statement
DECLARE Statement
IF/ELSE Statement
RETURN Statement
SET Statement
WHILE Statement

System Requirements
Host
Client

Setting up Logging
ODBC
Host-based Logging
ODBC Client-based Logging
PCSNI Logging

JDBC
Enabling Logging

SQL Reserved Keywords
SQL Environment Files
SQLINFO File
SQLTYPES File
SQLTABLES File
SQLCOLUMNS File
SQLINDEXES File

PERSONNEL File
Format of the PERSONNEL File
PERSONNEL Data
PERSONNEL Data definition items

UNIX-Connect
External Interfaces
Other Documents